Customize Style tab

Use the Customize Style tab to format your cross-tab's grid with background color, gridlines, and cell margins.

Columns

This list displays the columns you selected for your cross-tab. Select the field for which you want to customize the style.

Rows

This list displays the rows you selected for your cross-tab. Select the field for which you want to customize the style.

Suppress Subtotal

Use this check box to suppress the subtotal for a selected field. You must first have a field selected in either the Rows list or the Columns list.

Suppress Label

Use this check box to suppress the label of a suppressed subtotal field. This check box is inactive if the Suppress Subtotal check box is not selected.

Alias for Formulas

Enter an alias name for the selected row or column field. Creating an alias shortens long field names, which is useful later when you refer to a field in a conditional formatting formulas. The field's original name is shown in this box by default.

Background Color

Use this list to select a color for the selected row or column field.

Show Cell Margins

Select this check box to have the program automatically format the cells of the cross-tab. When this check box is not selected, any extra space (white space) within the cells of the cross-tab will be eliminated and the contents of the cells will be adjusted to utilize the least amount of space in your report as possible.

Indent Row Labels

Select this check box to indent row labels on your cross-tab. Use the inches box to specify the size of the indent you want to see.

Format grid lines

When you click this button, the Format Grid Lines dialog box appears. In this dialog box, you can define whether the grid lines are shown or not, as well as the color, style, and width you'd like the grid lines to have.

Repeat Row Labels

Select this check box to have the program repeat row labels on every page for cross-tabs that print across more than one page.

Keep Columns Together

Select this check box to have the program keep columns together on every page for cross-tabs that print across more than one page.

Row totals on Top

Select this check box if you want row totals to appear at the top of the cross-tab rather than at the bottom (the default position).

Column totals on Left

Select this check box if you want column dimensions to appear on the left of the cross-tab rather than on the right (the default position).

Suppress Empty Rows

Select this check box to have the program remove empty rows from the cross-tab. When this check box is selected, any rows whose fields do not contain any records will be hidden.

Suppress Empty Columns

Select this check box to have the program remove empty columns from the cross-tab. When this check box is selected, any columns whose fields do not contain any records will be hidden.

Suppress Row Grand Totals

Select this check box to have the program remove the grand total from rows in the cross-tab.

Suppress Column Grand Totals

Select this check box to have the program remove the grand total from columns in the cross-tab.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com